Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerDeliveryID (PK) | A TOKEN identifier for a CustomerDelivery entity type instance. | ID_CT_DV | Identity | integer | |
EstimatedShippingHandlingFeeAmount | The estimated monetary amount of the total shipping and handling costs associated with this CustomerDelivery. This value only includes shipping and handling fees it does NOT include the cost of merchandise, taxes and non-transport related charges. | MO_PYM_RQ | MoneyShortRetail | decimal(7,2) | |
SpecialInstructions | Narrative text, giving special delivery instructions. | NA_INST_SPL | DescriptionNarrative | varchar(4000) | |
CustomerOrderGroupID (FK) | A unique system assigned identifier for the group of line items from a Customer placed order, recording how the Customer wishes the StockItems that have been orderd are to be given to the Customer. | ID_CTORD_GRP | Identity | integer | CustomerOrderProductGroup(CO_CTORD_GRP) |
ShipmentID (FK) | A unique, retailer supplied identifier for a RetailTransactionShipment. | ID_SHP | Identity | integer | CustomerOrderShipment(TR_SHP_CT_ORD) |
Requested (FK) | A designated code and enumerated value list that categorizes different ways of paying for transporation services related to a shipment/delivery of merchandise. These typically apply to COD or scenarios where the merchandise is paid for through another means but the customer must pay transport fees on delivery. GS1 examples include: BANK_CHEQUE BANK_GIRO BANKERS_DRAFT BOOKENTRY_CREDIT BOOKENTRY_DEBIT BOP CASH CERTIFIED_CHEQUE CHEQUE CREDIT_CARD DEBIT_CARD ELECTRONIC_CREDIT_ACH ELECTRONIC_DEBIT_ACH FED_WIRE_NON_REPETITIVE FED_WIRE_REPETITIVE INTERNATIONAL_WIRE LETTER_OF_CREDIT POSTGIRO WIRE_TRANSFER_CREDIT WIRE_TRANSFER_DEBIT | CD_TRNSPRT_PYM_MTH | Name | varchar(40) | TransportPaymentMethod(CO_TRNSPRT_PYM_MTH) |
RequestedLevel (FK) | Identifies a transportation service level type used to distinguish faster from slower delivery plus additional tracking and ancillary services. Sample GS1 code values: AUTHORIZED_RETURN_SERVICE CONSIGNEE_BILLING_SERVICE DELIVERY_CONFIRMATION EXPEDITED_SERVICE EXPEDITED_SERVICE_WORLDWIDE EXPRESS_SERVICE EXPRESS_SERVICE_PLUS GROUND GROUND_CX_EXPRESS_SERVICE MULTIWEIGHT MUTUALLY_DEFINED NEXT_DAY_AIR NEXT_DAY_PM NEXT_MORNING PRIMARY_SERVICE_AREA_NEXT_DAY_BY_1030 PRIMARY_SERVICE_AREA_NEXT_DAY_BY_1700 RETURN_SERVICE SAME_DAY SATURDAY SATURDAY_PICKUP SECOND_DAY_AIR SECOND_MORNING STANDARD_GROUND_HUNDRED_WEIGHT STANDARD_SERVICE THREE_DAY_SERVICE | CD_RQSD_LV | Code | varchar(20) | TransportServiceLevelType(CO_TRNSPRT_PYM_SV_LV_TYP) |
CarrierServiceID (FK) | Token identifier for a CarrierService instance | ID_CRR_SV | Identity | integer | CarrierService(CO_CRR_SV) |
ShipMethodID (FK) | Token identifier for a ShipMethodInstance | ID_SHP_MTH | Identity | integer | ShipMethod(CO_SHP_MTH) |
TransportBillingMethodCode (FK) | Retailer designated code that indicates how the transportation and handling fees for a shipment are to be billed. Sample values (for domestic US shipments) include: PREPAID = prepaid transportation fees COL = collect upon delivery from receipient BRC = Bill the receiver B3P = Bill 3rd party Others may be added as required for international shipping and other kinds of shipping arrangements. | CD_TRNSPRT_BLLNG_MTH | Code | varchar(20) | TransportBillingMethod(CO_TRNSPRT_BLLNG_MTH) |
EstimatedCollectOnDeliveryAmount | The estimated monetary value due to be collected from a customer at the time of delivery. This value is determined by the retailer and may include the cost of merchandise plus applicable taxes plus shipping and handling charges. Care must be exer | MO_ESTM_CLLCT_ON_DV_AMT | Money | decimal(16,5) | |